CREATE TABLE [dbo].[JOL_Employee]
(
[JOL_Employee_No] [int] NOT NULL IDENTITY(1, 1),
[JOL_Employee_Account] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[JOL_Employee_Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Sex] [bit] NULL,
[JOL_Employee_School] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Profession] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Longevity] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_StudyMethod] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_TrainMethod] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_StudyYearIn] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_StudyYearOut] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_IDCardNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Nation] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Politics] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Province] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Place] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_TrainUnit] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Mobile] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_Email] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_CredentialsFileLink] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_AddTime] [datetime] NULL,
[JOL_Employee_AddUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_UpdateTime] [datetime] NULL,
[JOL_Employee_UpdateUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_VerifyStatus] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Emplo__JOL_E__17786E0C] DEFAULT ('未审核'),
[JOL_Employee_VerifyTime] [datetime] NULL,
[JOL_Employee_VerifyUser] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[JOL_Employee_VerifyIsSendEmail] [bit] NULL CONSTRAINT [DF__JOL_Emplo__JOL_E__186C9245] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Employee] ADD CONSTRAINT [PK__JOL_Employee__1590259A] PRIMARY KEY CLUSTERED  ([JOL_Employee_No]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Employee] ADD CONSTRAINT [UQ__JOL_Employee__168449D3] UNIQUE NONCLUSTERED  ([JOL_Employee_Account]) ON [PRIMARY]
GO
